package com.flong.modules.tools;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import com.flong.modules.AppException;
import com.flong.modules.service.TableColumnsService;
import com.flong.modules.service.TableService;
import com.flong.modules.utils.DBHelper;
import com.flong.modules.utils.ObjectUtil;
import com.flong.modules.utils.PropertiesHelper;
/**
 * @Description	SqlScriptGenerator
 * @ClassName	SqlScriptGenerator
 * @Date		2017年2月23日 下午2:10:36
 * @Author		liangjilong
 * @Copyright (c) All Right Reserved, 2017.
 */
@SuppressWarnings("all")
public class SqlScriptGenerator {
	
	public static void main(String[] args) throws Exception {
		/*List<Table> tables = TableService.getTablesBySuffix("T_ATS_");
		for(String table:tables){
			System.out.println(table);
			List<Map<String,Object>> cols = TableService.getCols(table);
			for (Map<String,Object> col:cols) {
				System.out.println(col);
			}
		}*/
		
		
		/*List<Map<String,Object>> cols = TableService.getCols("T_ATS_CJAPI_BID_CONFIRM_INFO");
		for (Map<String,Object> col:cols) {
			System.out.println(col);
		}
		
		int countByTable = TableHelper.getCountByTable("T_ATS_CJAPI_BID_CONFIRM_INFO");
		System.out.println(countByTable);*/
	}
}
